[dbo].[BAECartOrderInsert]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@CartItemID	int	4
@Quantity	int	4
@Price	money	8
@Title	varchar(128)	128
@ProductCode	varchar(64)	64
@OrderProductID	int	4

SQL Script

create procedure [dbo].[BAECartOrderInsert] @CartItemID as
int,
    @Quantity AS int,
    @Price AS money,
    @Title AS varchar(128),
    @ProductCode AS varchar(64),
    @OrderProductID AS int
AS
    INSERT INTO CartOrder
    (CartItemID, Quantity,
    Price,
    Title,
    ProductCode,
    OrderProductID)
    VALUES
    (@CartItemID, @Quantity,
    @Price,
    @Title,
    @ProductCode,
    @OrderProductID);

SELECT CAST(@@IDENTITY AS int) AS 'InsertedCartOrder';

GO